﻿<%@ Page Title="Home Page" Language="vb" MasterPageFile="~/Site.Master" AutoEventWireup="false"
    CodeBehind="Default.aspx.vb" Inherits="SingerProfile._Default" %>

<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
    <h2>
        Welcome to <asp:LoginName ID="LoginName1" runat="server" /></h2>
     
    <p>
        This Site is al about &quot; Robbie Williams &quot;, who is famous singer and song Writer 
        in United Kingdom. You can view recent albums and Upcoming Live Events</p>
    
        &nbsp;<br />
      
   <fieldset>
   <legend> This Month Events </legend>



       <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" 
           CellPadding="4" DataSourceID="SqlDataSource1" ForeColor="#333333" 
           GridLines="None" Width="100%">
           <AlternatingRowStyle BackColor="White" />
           <Columns>
               <asp:BoundField DataField="event_name" HeaderText="event_name" 
                   SortExpression="event_name" />
               <asp:BoundField DataField="event_date_time" HeaderText="event_date_time" 
                   SortExpression="event_date_time" />
               <asp:BoundField DataField="event_location" HeaderText="event_location" 
                   SortExpression="event_location" />
               <asp:HyperLinkField DataNavigateUrlFields="event_postcode" 
                   DataNavigateUrlFormatString="https://maps.google.co.uk/maps?q={0}&amp;hl=en" 
                   DataTextField="event_postcode" HeaderText="Location" Text="Location" />
           </Columns>
           <EditRowStyle BackColor="#7C6F57" />
           <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
           <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
           <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
           <RowStyle BackColor="#E3EAEB" />
           <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
           <SortedAscendingCellStyle BackColor="#F8FAFA" />
           <SortedAscendingHeaderStyle BackColor="#246B61" />
           <SortedDescendingCellStyle BackColor="#D4DFE1" />
           <SortedDescendingHeaderStyle BackColor="#15524A" />
       </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:SingerProfileConStr %>" 
            ProviderName="<%$ ConnectionStrings:SingerProfileConStr.ProviderName %>" 
            
           
           SelectCommand="SELECT [event_name], [event_date_time], [event_location], [event_postcode] FROM [Qry_ThisMonthEvents] ORDER BY [event_date_time]">
        </asp:SqlDataSource>
   


   </fieldset>
    
   <fieldset>
   <legend> Recent albums </legend>
   

        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
            CellPadding="4" DataSourceID="SqlDataSource2" ForeColor="#333333" 
            GridLines="None" Width="100%">
            <AlternatingRowStyle BackColor="White" />
            <Columns>
                <asp:ImageField DataAlternateTextField="Cover_Picture" 
                    DataImageUrlField="Cover_Picture" HeaderText="Album Cover">
                    <ControlStyle Height="80px" Width="80px" />
                </asp:ImageField>
                <asp:BoundField DataField="Album_Name" SortExpression="Album_Name" 
                    HeaderText="Album_Name" />
                <asp:BoundField DataField="Release_year" HeaderText="Release_year" 
                    SortExpression="Release_year" />
            </Columns>
            <EditRowStyle BackColor="#7C6F57" />
            <FooterStyle BackColor="#1C5E55" ForeColor="White" Font-Bold="True" />
            <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#E3EAEB" />
            <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
            <SortedAscendingCellStyle BackColor="#F8FAFA" />
            <SortedAscendingHeaderStyle BackColor="#246B61" />
            <SortedDescendingCellStyle BackColor="#D4DFE1" />
            <SortedDescendingHeaderStyle BackColor="#15524A" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
           ConnectionString="<%$ ConnectionStrings:SingerProfileConStr %>" 
           ProviderName="<%$ ConnectionStrings:SingerProfileConStr.ProviderName %>" 
           SelectCommand="SELECT [Cover_Picture], [Album_Name], [Release_year] FROM [Qry_Top3_Albums]">
       </asp:SqlDataSource>
   

   <br />
   </fieldset><br />
&nbsp;<p>
        *This Site created for Enducational Purpose - By Sainath Gurijala ( University 
        of Hertfordshire)</p>
    <p>
        &nbsp;</p>
</asp:Content>
